USE [MRFSQuery]
GO
/****** Object:  Table [dbo].[Table_Model]    Script Date: 2020/10/9 16:58:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_Model]
(
    [id] [nvarchar](50) NOT NULL,
    [name] [nvarchar](50) NULL,
    [shared] [bit] NULL,
    [grade] [int] NULL,
    [sharedUser] [nvarchar](max) NULL,
    [query] [nvarchar](max) NULL,
    [createTime] [datetime] NULL,
    [owner] [nvarchar](50) NULL,
    [lastExecuteTime] [datetime] NULL,
    [type] [nvarchar](50) NULL,
    [description] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020827143043545299', N'示例，诊断顺位表', 1, 0, N'', N'{"name":"示例，诊断顺位表","statistics":[{"conditions":[],"terms":[{"statistictype":"结果计数","target":"MRID","name":"病案号","parameter":"","show":"病案号"},{"statistictype":"联合分组平均","target":"InpatientDay","name":"住院天数","parameter":"","show":"住院天数"},{"statistictype":"联合分组平均","target":"Totalcost","name":"总花费金额","parameter":"","show":"总花费金额"},{"statistictype":"联合分组平均","target":"VFee.西药费","name":"西药费","parameter":"","show":"西药费"},{"statistictype":"联合分组前缀","target":"Diagnosis.InternalICDCode","name":"出院协和诊断编码","parameter":"5","show":"出院协和诊断编码"}],"caculateterms":[{"name":"计算列","parameter":"","form":"西药费/总花费金额"}]},{"conditions":[{"Target":"Diagnosis.DischargeState","Relation":"And","Operation":"Eq","Value":"治愈","Show":"疗效","DicTable":"Dic_CurativeEffect","DicColumns":"CurativeEffectName,CurativeEffectCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}],"terms":[{"statistictype":"结果计数","target":"MRID","name":"病案号","parameter":"","show":"病案号"}]}],"conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2019-01-01","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-09-27","Public":true},{"Target":"CodeState","Relation":"And","Operation":"Eq","Value":"1000","Show":"编码状态","DicTable":"","DicColumns":"value,show","Db":"","DataType":"","Options":[{"value":"100","show":"未开始编码"},{"value":"200","show":"编码中"},{"value":"300","show":"病理未归"},{"value":"400","show":"病理已归待编码"},{"value":"1000","show":"编码完成"}],"AddtionalValue":"","Public":false}]}],"expression":"","parameter":{}}', CAST(N'2020-09-27T06:28:03.343' AS DateTime), N'admin', NULL, N'aggregation', N'协和诊断前缀顺位表样例，包括计算列')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020829151132746375', N'库欣综合征 and 静脉血栓', 0, 0, N'', N'{"name":"库欣综合征 and 静脉血栓","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2013-01-01","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-09-29","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"in","Value":"库欣病,促肾上腺皮质激素瘤,垂体依赖性库欣病,促肾上腺皮质激素生成过多,纳尔逊综合征,药物性库欣综合征,医源性库欣综合征,类库欣综合征,异位促肾上腺皮质激素综合征,异位促肾上腺皮质激素瘤,醇诱发的假库欣综合征,糖皮质激素过度敏感综合征,ACTH依赖型亚临床库欣综合征,ACTH非依赖型库欣综合征,Carney综合征,周期性库欣综合征,皮质醇增多症,库欣综合征,高皮质醇血症,亚临床库欣综合征","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"in","Value":"脾静脉血栓形成,大脑静脉血栓形成,大隐静脉血栓形成,股静脉血栓形成,髂股静脉血栓形成,下肢深静脉血栓形成,手术后下肢深静脉血栓形成,髂静脉血栓形成,下肢静脉血栓形成,门静脉血栓形成,肝中静脉血栓形成,肝静脉血栓形成,腔静脉血栓形成,下腔静脉血栓形成,肾静脉血栓形成,锁骨下静脉血栓形成,腋静脉血栓形成,颈静脉血栓形成,上肢静脉血栓形成,静脉血栓形成,肠系膜静脉血栓形成伴肠坏死,肠系膜静脉血栓形成,人工流产后下肢静脉血栓,妊娠期深静脉血栓形成,妊娠期大脑静脉血栓形成,产褥期深静脉血栓形成,产褥期大脑静脉血栓形成,产褥期上肢静脉血栓,创伤性股动静脉血栓形成","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":true,"sequence":false,"strict":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}},"version":3}', CAST(N'2020-09-29T07:07:13.833' AS DateTime), N'test', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202071216045397420', N'急性心肌梗死', 0, 0, N'', N'{"name":"UntitledAgg","statistics":[{"conditions":[],"terms":[{"statistictype":"结果计数","target":"MRID","name":"病案号","parameter":"","show":"病案号"}],"caculateterms":[]}],"conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"Eq","Value":"I21.001,I21.002,I21.003,I21.004,I21.101,I21.102,I21.103,I21.104,I21.201,I21.202,I21.203,I21.204,I21.205,I21.206,I21.207,I21.208,I21.209,I21.210,I21.304,I21.305,I21.401,I21.402,I21.403,I21.901,I21.902","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Except","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"Eq","Value":"Z37.001,Z37.002,Z37.003,Z37.101,Z37.201,Z37.202,Z37.203,Z37.204,Z37.301,Z37.302,Z37.303,Z37.304,Z37.305,Z37.306,Z37.307,Z37.308,Z37.309,Z37.401,Z37.402,Z37.501,Z37.502,Z37.601","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"expression":"","parameter":{}}', CAST(N'2020-08-12T07:50:13.290' AS DateTime), N'test', NULL, N'aggregation', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202072416122882842', N'基本外科检索1', 1, 0, N'', N'{"name":"基本外科检索1","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"JBWK-基本外科","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"CodeState","Relation":"And","Operation":"Eq","Value":"","Show":"编码状态","DicTable":"","DicColumns":"value,show","Db":"","DataType":"","Options":[{"value":"100","show":"未开始编码"},{"value":"200","show":"编码中"},{"value":"300","show":"病理未归"},{"value":"400","show":"病理已归待编码"},{"value":"1000","show":"编码完成"}],"AddtionalValue":"","Public":false},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false},{"Target":"Nation","Relation":"And","Operation":"Eq","Value":"","Show":"民族","DicTable":"BaseDic_Nation","DicColumns":"NationName,NationCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"HukouAddressDetail","Relation":"And","Operation":"Eq","Value":"","Show":"户口住址详细地址","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VContact.PhoneNum","Relation":"And","Operation":"Eq","Value":"","Show":"联系人电话","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false},{"Target":"InDepart","Relation":"And","Operation":"Eq","Value":"","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"InpatientDay","Relation":"And","Operation":"Eq","Value":"","Show":"住院天数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false},{"Target":"Doctor.科主任.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"科主任","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Doctor.主任医师.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"主任医师","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Doctor.主治医师.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"主治医师","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.InternalICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.OperateBeginTime","Relation":"And","Operation":"Eq","Value":"","Show":"手术开始时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalPathologyICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和病理编码","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.OperatorName","Relation":"And","Operation":"Eq","Value":"","Show":"手术术者","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VClinicDiagnosis.InternalPathologyICDName","Relation":"And","Operation":"Eq","Value":"","Show":"门急诊协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VClinicDiagnosis.InternalPathologyICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"门急诊协和病理编码","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"showColumn":[],"parameter":{"isMridMode":false}}', CAST(N'2020-08-24T07:59:44.193' AS DateTime), N'test', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202072618430669260', N'核查数据准确性', 0, 0, N'', N'{"name":"UntitledQuery","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"VSurgery.InternalICDCode","Relation":"And","Operation":"notempty","Value":"","Show":"协和手术编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"C56  01,C56  02,C56  03,C56  04,C56  05,C56  06,C56  07,C56  08,C56  09","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"showColumn":[],"parameter":{"isMridMode":false}}', CAST(N'2020-08-26T10:03:50.143' AS DateTime), N'test', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202071195110727361', N'手术顺位表', 0, 0, N'', N'{"name":"手术顺位表","statistics":[{"conditions":[],"terms":[{"statistictype":"联合分组前缀","target":"VSurgery.OperateICDCode","name":"北京手术编码","parameter":"5","show":"北京手术编码"},{"statistictype":"联合分组平均","target":"InpatientDay","name":"住院天数","parameter":"","show":"住院天数"},{"statistictype":"联合分组平均","target":"VSurgery.BeforeOperateTime","name":"手术前时间（小时）","parameter":"","show":"手术前时间（小时）"},{"statistictype":"联合分组平均","target":"VSurgery.AfterOperateTime","name":"手术后时间（小时）","parameter":"","show":"手术后时间（小时）"},{"statistictype":"联合分组平均","target":"VSurgery.OperateDuringTime","name":"手术时间（小时）","parameter":"","show":"手术时间（小时）"},{"statistictype":"联合分组平均","target":"Totalcost","name":"总花费金额","parameter":"","show":"总花费金额"}],"caculateterms":[]},{"conditions":[{"Target":"DischargePath","Relation":"And","Operation":"Eq","Value":"死亡","Show":"离院方式","DicTable":"Dic_DischargeType","DicColumns":"DischargeType,DischargeCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}],"terms":[{"statistictype":"联合分组计数","target":"MRID","name":"病案号","parameter":"","show":"病案号"}],"caculateterms":[]}],"conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"CodeState","Relation":"And","Operation":"Eq","Value":"1000","Show":"编码状态","DicTable":"","DicColumns":"value,show","Db":"","DataType":"","Options":[{"value":"100","show":"未开始编码"},{"value":"200","show":"编码中"},{"value":"300","show":"病理未归"},{"value":"400","show":"病理已归待编码"},{"value":"1000","show":"编码完成"}],"AddtionalValue":"","Public":false},{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-01-01T16:00:00.000Z","Public":false}]}],"expression":"","parameter":{}}', CAST(N'2020-08-11T01:50:32.277' AS DateTime), N'test', NULL, N'aggregation', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202072618143178147', N'对数据的正确写法', 1, 0, N'', N'{"name":"UntitledQuery","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"VSurgery.InternalICDCode","Relation":"And","Operation":"notempty","Value":"","Show":"协和手术编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"undefinedC56  01undefined,undefinedC56  02undefined,undefinedC56  03undefined,undefinedC56  04undefined,undefinedC56  05undefined,undefinedC56  06undefined,undefinedC56  07undefined,undefinedC56  08undefined,undefinedC56  09undefined","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"showColumn":[],"parameter":{"isMridMode":false}}', CAST(N'2020-08-26T10:06:06.220' AS DateTime), N'test', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model20208171635913817', N'第二次导出死机', 0, 0, N'', N'{"name":"第二次导出死机","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2009-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-09-16T16:00:00.000Z","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"E11.602,E14.608+I43.805*,E63.903+I43.201*,E83.105+I43.104*,E88.901+I43.103*,I11.902,I25.502,I42.001,I42.001,I42.002,I42.101,I42.201,I42.501,I42.601,I42.701,I42.801,I42.803,I42.804,I42.901,I42.902,I42.903,I42.904,I51.504,I51.506,I51.805,M30.106+I43.107*,M32.104+I43.806*,N18.803+I43.807*,O90.301","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"HospitalizedTimes","Relation":"And","Operation":"Eq","Value":"","Show":"住院次数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VContact.PhoneNum","Relation":"And","Operation":"Eq","Value":"","Show":"联系人电话","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"CurrentAddressDetail","Relation":"And","Operation":"Eq","Value":"","Show":"现在住址详细地址","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"CurrentProvince","Relation":"And","Operation":"Eq","Value":"","Show":"现在地址（省）","DicTable":"BaseDic_Province","DicColumns":"ProvinceName,ProvinceCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"CurrentCity","Relation":"And","Operation":"Eq","Value":"","Show":"现在地址（市）","DicTable":"BaseDic_City","DicColumns":"CityName,CityCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"CurrentArea","Relation":"And","Operation":"Eq","Value":"","Show":"现在地址（县）","DicTable":"BaseDic_Area","DicColumns":"AreaName,AreaCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":true,"sequence":false,"strict":false,"limit":{"Diagnosis":7,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":5,"VSurgery":5,"VTransfer":0,"VContact":0,"VICU":0}},"version":2}', CAST(N'2020-09-17T07:47:53.957' AS DateTime), N'', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202071410560711868', N'朱瑞要的查询 差集', 0, 0, N'', N'{"name":"UntitledQuery","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"pre","Value":"N80.0","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"CodeState","Relation":"And","Operation":"Eq","Value":"1000","Show":"编码状态","DicTable":"","DicColumns":"value,show","Db":"","DataType":"","Options":[{"value":"100","show":"未开始编码"},{"value":"200","show":"编码中"},{"value":"300","show":"病理未归"},{"value":"400","show":"病理已归待编码"},{"value":"1000","show":"编码完成"}],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Except","conditions":[{"Target":"CodeState","Relation":"And","Operation":"Eq","Value":"1000","Show":"编码状态","DicTable":"","DicColumns":"value,show","Db":"","DataType":"","Options":[{"value":"100","show":"未开始编码"},{"value":"200","show":"编码中"},{"value":"300","show":"病理未归"},{"value":"400","show":"病理已归待编码"},{"value":"1000","show":"编码完成"}],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"pre","Value":"C54.1","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"showColumn":[],"parameter":{"isMridMode":false}}', CAST(N'2020-08-14T02:55:38.023' AS DateTime), N'test', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020724162220680800', N'基本外科检索2', 0, 0, N'', N'{"name":"UntitledQuery","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"CodeState","Relation":"And","Operation":"Eq","Value":"1000","Show":"编码状态","DicTable":"","DicColumns":"value,show","Db":"","DataType":"","Options":[{"value":"100","show":"未开始编码"},{"value":"200","show":"编码中"},{"value":"300","show":"病理未归"},{"value":"400","show":"病理已归待编码"},{"value":"1000","show":"编码完成"}],"AddtionalValue":"","Public":false},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"JBWK-基本外科","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"Or","Operation":"pre","Value":"C73","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDName","Relation":"Or","Operation":"Eq","Value":"甲状腺肿物","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.InternalICDCode","Relation":"And","Operation":"pre","Value":"06.2","Show":"协和手术编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false},{"Target":"Nation","Relation":"And","Operation":"Eq","Value":"","Show":"民族","DicTable":"BaseDic_Nation","DicColumns":"NationName,NationCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"HukouAddressDetail","Relation":"And","Operation":"Eq","Value":"","Show":"户口住址详细地址","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VContact.PhoneNum","Relation":"And","Operation":"Eq","Value":"","Show":"联系人电话","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false},{"Target":"InpatientDay","Relation":"And","Operation":"Eq","Value":"","Show":"住院天数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false},{"Target":"Doctor.科主任.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"科主任","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Doctor.主任医师.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"主任医师","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Doctor.主治医师.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"主治医师","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.OperatorName","Relation":"And","Operation":"Eq","Value":"","Show":"手术术者","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.OperateBeginTime","Relation":"And","Operation":"Eq","Value":"","Show":"手术开始时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalPathologyICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和病理编码","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VClinicDiagnosis.InternalPathologyICDName","Relation":"And","Operation":"Eq","Value":"","Show":"门急诊协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VClinicDiagnosis.InternalPathologyICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"门急诊协和病理编码","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"showColumn":[],"parameter":{"isMridMode":false}}', CAST(N'2020-08-24T08:20:29.440' AS DateTime), N'test', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020719113227488214', N'诊断顺位表', 0, 0, N'', N'{"name":"诊断顺位表带计算列1","statistics":[{"conditions":[],"terms":[{"statistictype":"联合分组前缀","target":"Diagnosis.DiagnosisICDCode","name":"出院北京诊断编码","parameter":"3","show":"出院北京诊断编码"},{"statistictype":"结果计数","target":"MRID","name":"病案号","parameter":"","show":"病案号"},{"statistictype":"联合分组平均","target":"InpatientDay","name":"住院天数","parameter":"","show":"住院天数"},{"statistictype":"联合分组平均","target":"Totalcost","name":"总花费金额","parameter":"","show":"总花费金额"},{"statistictype":"联合分组平均","target":"VFee.西药费","name":"西药费","parameter":"","show":"西药费"}],"caculateterms":[{"name":"计算列","parameter":"","form":"西药费/总花费金额"}]},{"conditions":[{"Target":"Diagnosis.DischargeState","Relation":"And","Operation":"Eq","Value":"治愈","Show":"疗效","DicTable":"Dic_CurativeEffect","DicColumns":"CurativeEffectName,CurativeEffectCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}],"terms":[{"statistictype":"结果计数","target":"MRID","name":"病案号","parameter":"","show":"病案号"}]}],"conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-01-01T16:00:00.000Z","Public":false},{"Target":"CodeState","Relation":"And","Operation":"Eq","Value":"","Show":"编码状态","DicTable":"","DicColumns":"value,show","Db":"","DataType":"","Options":[{"value":"100","show":"未开始编码"},{"value":"200","show":"编码中"},{"value":"300","show":"病理未归"},{"value":"400","show":"病理已归待编码"},{"value":"1000","show":"编码完成"}],"AddtionalValue":"","Public":false},{"Target":"Age","Relation":"And","Operation":"<","Value":30,"Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"女","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"expression":"","parameter":{}}', CAST(N'2020-08-19T03:31:54.767' AS DateTime), N'test', NULL, N'aggregation', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202082713534577063', N'示例，诊断手术和费用信息', 1, 0, N'', N'{"name":"示例，诊断手术和费用信息","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2020-09-01","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-09-27","Public":true,"IsShow":true},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InDepart","Relation":"And","Operation":"Eq","Value":"","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InpatientDay","Relation":"And","Operation":"Eq","Value":"","Show":"住院天数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargePath","Relation":"And","Operation":"Eq","Value":"","Show":"离院方式","DicTable":"Dic_DischargeType","DicColumns":"DischargeType,DischargeCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"RespiratorTime","Relation":"And","Operation":"Eq","Value":"","Show":"呼吸机使用时间","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VICU.ICUName","Relation":"And","Operation":"Eq","Value":"","Show":"重症监护室名称","DicTable":"Dic_IcuType","DicColumns":"ICUName,ICUCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.InternalICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InSickRoom","Relation":"And","Operation":"Eq","Value":"","Show":"入院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.中医治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"中医治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.西药费","Relation":"And","Operation":"Eq","Value":"","Show":"西药费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.诊查费","Relation":"And","Operation":"Eq","Value":"","Show":"诊查费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.介入用一次性医用材料费","Relation":"And","Operation":"Eq","Value":"","Show":"介入用一次性医用材料费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.核素检查","Relation":"And","Operation":"Eq","Value":"","Show":"核素检查","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.护理治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"护理治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.介入治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"介入治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.麻醉费","Relation":"And","Operation":"Eq","Value":"","Show":"麻醉费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.手术用一次性医用材料费","Relation":"And","Operation":"Eq","Value":"","Show":"手术用一次性医用材料费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.治疗用一次性医用材料费","Relation":"And","Operation":"Eq","Value":"","Show":"治疗用一次性医用材料费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.接生费","Relation":"And","Operation":"Eq","Value":"","Show":"接生费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.监护及辅助呼吸设备费","Relation":"And","Operation":"Eq","Value":"","Show":"监护及辅助呼吸设备费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.核素治疗","Relation":"And","Operation":"Eq","Value":"","Show":"核素治疗","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.病理费","Relation":"And","Operation":"Eq","Value":"","Show":"病理费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.精神治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"精神治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.凝血因子类制品费","Relation":"And","Operation":"Eq","Value":"","Show":"凝血因子类制品费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.输血费","Relation":"And","Operation":"Eq","Value":"","Show":"输血费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.中草药费","Relation":"And","Operation":"Eq","Value":"","Show":"中草药费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.床位费","Relation":"And","Operation":"Eq","Value":"","Show":"床位费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.白蛋白类制品费","Relation":"And","Operation":"Eq","Value":"","Show":"白蛋白类制品费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.挂号费","Relation":"And","Operation":"Eq","Value":"","Show":"挂号费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.化验费","Relation":"And","Operation":"Eq","Value":"","Show":"化验费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.康复治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"康复治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.其他","Relation":"And","Operation":"Eq","Value":"","Show":"其他","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.特殊治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"特殊治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.中成药费","Relation":"And","Operation":"Eq","Value":"","Show":"中成药费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.一般治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"一般治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.超声费","Relation":"And","Operation":"Eq","Value":"","Show":"超声费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.输氧费","Relation":"And","Operation":"Eq","Value":"","Show":"输氧费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.放射费","Relation":"And","Operation":"Eq","Value":"","Show":"放射费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.抗菌药物费","Relation":"And","Operation":"Eq","Value":"","Show":"抗菌药物费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.球蛋白类制品费","Relation":"And","Operation":"Eq","Value":"","Show":"球蛋白类制品费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.检查用一次性医用材料费","Relation":"And","Operation":"Eq","Value":"","Show":"检查用一次性医用材料费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.费用值","Relation":"And","Operation":"Eq","Value":"","Show":"费用值","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.护理费","Relation":"And","Operation":"Eq","Value":"","Show":"护理费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.一般检查费","Relation":"And","Operation":"Eq","Value":"","Show":"一般检查费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.临床物理治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"临床物理治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.手术费","Relation":"And","Operation":"Eq","Value":"","Show":"手术费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.细胞因子类制品费","Relation":"And","Operation":"Eq","Value":"","Show":"细胞因子类制品费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}}}', CAST(N'2020-09-27T05:51:40.217' AS DateTime), N'test', NULL, N'query', N'查询时间区间内的诊断，手术和费用信息')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202071217161548532', N'急性心肌梗死', 0, 0, N'', N'{"name":"UntitledAgg","statistics":[{"conditions":[],"terms":[{"statistictype":"结果计数","target":"MRID","name":"病案号","parameter":"","show":"病案号"}],"caculateterms":[]}],"conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"BaseDiagnosis.InternalICDCode","Relation":"And","Operation":"Eq","Value":"I21.001,I21.002,I21.003,I21.004,I21.101,I21.102,I21.103,I21.104,I21.201,I21.202,I21.203,I21.204,I21.205,I21.206,I21.207,I21.208,I21.209,I21.210,I21.304,I21.305,I21.401,I21.402,I21.403,I21.901,I21.902","Show":"出院主协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Except","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"Eq","Value":"Z37.001,Z37.002,Z37.003,Z37.101,Z37.201,Z37.202,Z37.203,Z37.204,Z37.301,Z37.302,Z37.303,Z37.304,Z37.305,Z37.306,Z37.307,Z37.308,Z37.309,Z37.401,Z37.402,Z37.501,Z37.502,Z37.601","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Except","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"VSurgery.InternalICDCode","Relation":"And","Operation":">=","Value":"35.0101","Show":"协和手术编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"39.9806","Public":false},{"Target":"VSurgery.InternalICDCode","Relation":"And","Operation":"<=","Value":"39.9806","Show":"协和手术编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"expression":"","parameter":{}}', CAST(N'2020-08-12T07:50:13.290' AS DateTime), N'test', NULL, N'aggregation', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202072795959192919', N'信息准确性核对', 0, 0, N'', N'{"name":"UntitledQuery","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2009-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-08-26T16:00:00.000Z","Public":false},{"Target":"VSurgery.InternalICDCode","Relation":"And","Operation":"notempty","Value":"","Show":"协和手术编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"XWK-胸外科","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"showColumn":[],"parameter":{"isMridMode":false}}', CAST(N'2020-08-27T01:15:04.947' AS DateTime), N'test', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020728114845275235', N'协和顺位表示例', 0, 0, N'', N'{"name":"诊断顺位表带计算列1","statistics":[{"conditions":[],"terms":[{"statistictype":"联合分组平均","target":"InpatientDay","name":"住院天数","parameter":"","show":"住院天数"},{"statistictype":"联合分组平均","target":"Totalcost","name":"总花费金额","parameter":"","show":"总花费金额"},{"statistictype":"联合分组平均","target":"VFee.西药费","name":"西药费","parameter":"","show":"西药费"},{"statistictype":"联合分组前缀","target":"Diagnosis.InternalICDCode","name":"出院协和诊断编码","parameter":"5","show":"出院协和诊断编码"}],"caculateterms":[{"name":"计算列","parameter":"","form":"西药费/总花费金额"}]}],"conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-07-02T16:00:00.000Z","Public":false}]}],"expression":"","parameter":{}}', CAST(N'2020-08-28T02:59:02.917' AS DateTime), N'', NULL, N'aggregation', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020728135633158788', N'协和顺位表示例', 0, 0, N'', N'{"name":"诊断顺位表带计算列1","statistics":[{"conditions":[],"terms":[{"statistictype":"联合分组平均","target":"InpatientDay","name":"住院天数","parameter":"","show":"住院天数"},{"statistictype":"联合分组平均","target":"Totalcost","name":"总花费金额","parameter":"","show":"总花费金额"},{"statistictype":"联合分组平均","target":"VFee.西药费","name":"西药费","parameter":"","show":"西药费"},{"statistictype":"联合分组前缀","target":"Diagnosis.InternalICDCode","name":"出院协和诊断编码","parameter":"5","show":"出院协和诊断编码"}],"caculateterms":[{"name":"计算列","parameter":"","form":"西药费/总花费金额"}]}],"conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-07-24T16:00:00.000Z","Public":false}]}],"expression":"","parameter":{}}', CAST(N'2020-08-28T02:59:02.917' AS DateTime), N'', NULL, N'aggregation', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020728145929705341', N'核对数据', 1, 0, N'', N'{"name":"UntitledQuery","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2009-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-07-31T16:00:00.000Z","Public":false},{"Target":"VSurgery.InternalICDCode","Relation":"And","Operation":"notempty","Value":"","Show":"协和手术编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"XWK-胸外科","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.InternalICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.OperateOrder","Relation":"And","Operation":"Eq","Value":"","Show":"手术顺序","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false},{"Target":"CodeState","Relation":"And","Operation":"Eq","Value":"1000","Show":"编码状态","DicTable":"","DicColumns":"value,show","Db":"","DataType":"","Options":[{"value":"100","show":"未开始编码"},{"value":"200","show":"编码中"},{"value":"300","show":"病理未归"},{"value":"400","show":"病理已归待编码"},{"value":"1000","show":"编码完成"}],"AddtionalValue":"","Public":false}]}],"showColumn":[],"parameter":{"isMridMode":false}}', CAST(N'2020-08-28T06:23:49.133' AS DateTime), N'', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model20208313411343645', N'基外一病房', 0, 0, N'', N'{"name":"UntitledQuery","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"C25.701,C25.001,C25.101,C25.201,C25.301,C25.401,C25.402,C25.702,C25.801,C25.802,C25.803,C25.804,C25.901,C25.902,C25.903,C25.904","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalPathologyICDCode","Relation":"And","Operation":"in","Value":"M81510/0,M81510/1,M81510/6,M81511/3","Show":"出院协和病理编码","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"Eq","Value":"K86.901","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"K85.001,K85.002,K85.003,K85.004,K85.005,K85.006,K85.007,K85.008,K85.101,K85.201,K85.301,K85.302,K85.801,K85.802,K85.803,K85.804,K85.805,K85.806,K85.901,K86.001,K86.101,K86.102,K86.103,K86.104,K86.105,K86.106,K86.107,K86.108,K86.825,B25.201+K87.103*,B26.301+K87.101*","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"And","Operation":"in","Value":"小细胞神经内分泌癌,神经内分泌瘤,神经内分泌肿瘤(G1),神经内分泌肿瘤(G2),神经内分泌癌,转移性神经内分泌癌,混合性腺泡-神经内分泌癌,转移性混合性腺泡-神经内分泌癌,大细胞神经内分泌癌","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"And","Operation":"in","Value":"良性胃肠道间质瘤,胃肠道间质瘤(潜在恶性未肯定),胃肠道间质肉瘤,恶性胃肠道间质瘤,转移性胃肠道间质瘤","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"E66.101,E66.201,E66.201,E66.201,E66.801+N08.401*,E66.901,E66.902,E66.903,E66.903","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"E10.001,E10.002,E10.003,E10.101,E10.102,E10.103,E10.201+N08.303*,E10.202+N08.3*,E10.203+N08.3*,E10.204+N08.3*,E10.301+H36.001*,E10.302+H28.002*,E10.303+H36.0*,E10.401+G63.204*,E10.402+G99.003*,E10.403+G59.004*,E10.404+N33.802*,E10.501,E10.502+I79.202*,E10.601,E10.602,E10.603,E10.604,E10.701,E10.901,E10.902,E10.903,E10.904,E11.001,E11.002,E11.003,E11.004,E11.101,E11.102,E11.201+N08.301*,E11.202+N29.8*,E11.203+N08.307*,E11.204+N08.308*,E11.301+H36.002*,E11.302+H28.001*,E11.303+H36.005*,E11.304+H36.0*,E11.401+G63.203*,E11.402+N33.801*,E11.403+G59.003*,E11.404+G99.004*,E11.501,E11.502+I79.201*,E11.503,E11.504,E11.602,E11.603,E11.604,E11.605,E11.606,E11.701,E11.901,E11.902,E13.101,E13.201+N08.3*,E13.202+N08.305*,E13.203+N08.306*,E13.301+H36.004*,E13.401+G63.206*,E13.402+G63.2*,E13.601,E13.701,E13.702,E13.901,E13.902,E13.903,E13.904,E14.005,E14.006,E14.101,E14.102,E14.103,E14.201+N08.304*,E14.202+N08.302*,E14.202+N08.302*,E14.301+H36.003*,E14.303+H48.001*,E14.303+H48.001*,E14.401+G63.205*,E14.402+G99.001*,E14.405+G63.202*,E14.406+G73.003*,E14.408+G59.002*,E14.409+G99.002*,E14.410+G53.801*,E14.601,E14.602,E14.603,E14.604,E14.605,E14.606,E14.607+M14.692*,E14.608+I43.805*,E14.609+R23.801*,E14.610,E14.651,E14.701,E14.901","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Except","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"C73  01,C73  02,C73  03,C73  04,C73  05,C73  06,C73  07,C73  08,C75.001,C75.002,C79.815,D44.001,D44.201,D35.101,D35.102,D35.103","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}}}', CAST(N'2020-09-03T02:31:21.130' AS DateTime), N'', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202083104042113851', N'朱瑞 2019年 基本外科一病房', 1, 0, N'', N'{"name":"UntitledQuery","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"CodeState","Relation":"And","Operation":"Eq","Value":"1000","Show":"编码状态","DicTable":"","DicColumns":"value,show","Db":"","DataType":"","Options":[{"value":"100","show":"未开始编码"},{"value":"200","show":"编码中"},{"value":"300","show":"病理未归"},{"value":"400","show":"病理已归待编码"},{"value":"1000","show":"编码完成"}],"AddtionalValue":"","Public":false}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}}}', CAST(N'2020-09-03T02:36:25.860' AS DateTime), N'Ur20190729133721    ', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202083113440919374', N'基外一病房', 0, 0, N'', N'{"name":"UntitledQuery","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"C25.701,C25.001,C25.101,C25.201,C25.301,C25.401,C25.402,C25.702,C25.801,C25.802,C25.803,C25.804,C25.901,C25.902,C25.903,C25.904","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalPathologyICDCode","Relation":"And","Operation":"in","Value":"M81510/0,M81510/1,M81510/6,M81511/3","Show":"出院协和病理编码","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"Eq","Value":"K86.901","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"K85.001,K85.002,K85.003,K85.004,K85.005,K85.006,K85.007,K85.008,K85.101,K85.201,K85.301,K85.302,K85.801,K85.802,K85.803,K85.804,K85.805,K85.806,K85.901,K86.001,K86.101,K86.102,K86.103,K86.104,K86.105,K86.106,K86.107,K86.108,K86.825,B25.201+K87.103*,B26.301+K87.101*","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"And","Operation":"in","Value":"小细胞神经内分泌癌,神经内分泌瘤,神经内分泌肿瘤(G1),神经内分泌肿瘤(G2),神经内分泌癌,转移性神经内分泌癌,混合性腺泡-神经内分泌癌,转移性混合性腺泡-神经内分泌癌,大细胞神经内分泌癌","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"And","Operation":"in","Value":"良性胃肠道间质瘤,胃肠道间质瘤(潜在恶性未肯定),胃肠道间质肉瘤,恶性胃肠道间质瘤,转移性胃肠道间质瘤","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"E66.101,E66.201,E66.201,E66.201,E66.801+N08.401*,E66.901,E66.902,E66.903,E66.903","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Union","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"JBWKYBF-基本外科一病房","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"E10.001,E10.002,E10.003,E10.101,E10.102,E10.103,E10.201+N08.303*,E10.202+N08.3*,E10.203+N08.3*,E10.204+N08.3*,E10.301+H36.001*,E10.302+H28.002*,E10.303+H36.0*,E10.401+G63.204*,E10.402+G99.003*,E10.403+G59.004*,E10.404+N33.802*,E10.501,E10.502+I79.202*,E10.601,E10.602,E10.603,E10.604,E10.701,E10.901,E10.902,E10.903,E10.904,E11.001,E11.002,E11.003,E11.004,E11.101,E11.102,E11.201+N08.301*,E11.202+N29.8*,E11.203+N08.307*,E11.204+N08.308*,E11.301+H36.002*,E11.302+H28.001*,E11.303+H36.005*,E11.304+H36.0*,E11.401+G63.203*,E11.402+N33.801*,E11.403+G59.003*,E11.404+G99.004*,E11.501,E11.502+I79.201*,E11.503,E11.504,E11.602,E11.603,E11.604,E11.605,E11.606,E11.701,E11.901,E11.902,E13.101,E13.201+N08.3*,E13.202+N08.305*,E13.203+N08.306*,E13.301+H36.004*,E13.401+G63.206*,E13.402+G63.2*,E13.601,E13.701,E13.702,E13.901,E13.902,E13.903,E13.904,E14.005,E14.006,E14.101,E14.102,E14.103,E14.201+N08.304*,E14.202+N08.302*,E14.202+N08.302*,E14.301+H36.003*,E14.303+H48.001*,E14.303+H48.001*,E14.401+G63.205*,E14.402+G99.001*,E14.405+G63.202*,E14.406+G73.003*,E14.408+G59.002*,E14.409+G99.002*,E14.410+G53.801*,E14.601,E14.602,E14.603,E14.604,E14.605,E14.606,E14.607+M14.692*,E14.608+I43.805*,E14.609+R23.801*,E14.610,E14.651,E14.701,E14.901","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}}}', CAST(N'2020-09-03T02:31:21.130' AS DateTime), N'', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model20208894520288535', N'白雪要的新报表，据说崩溃', 0, 0, N'', N'{"name":"UntitledQuery","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"ReadmissionIn31","Relation":"And","Operation":"Eq","Value":"","Show":"出院31天再入院计划","DicTable":"Dic_ReadmissionIn31","DicColumns":"ReadmissionIn31Name,ReadmissionIn31Code","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}}}', CAST(N'2020-09-08T01:44:01.440' AS DateTime), N'', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model20208228333375907', N'DGRs', 0, 0, N'', N'{"name":"DGRs","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2019-06-30T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false,"IsShow":true},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"HospitalizedTimes","Relation":"And","Operation":"Eq","Value":"","Show":"住院次数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PaymentType","Relation":"And","Operation":"Eq","Value":"","Show":"医疗付款方式","DicTable":"Dic_PayType","DicColumns":"PayTypeName,PayTypeCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionPath","Relation":"And","Operation":"Eq","Value":"","Show":"入院途径","DicTable":"Dic_AdmissionPath","DicColumns":"AdmissionPath,AdmissionPathCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InpatientDay","Relation":"And","Operation":"Eq","Value":"","Show":"住院天数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InDepart","Relation":"And","Operation":"Eq","Value":"","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InSickRoom","Relation":"And","Operation":"Eq","Value":"","Show":"入院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VTransfer.TransferDate","Relation":"And","Operation":"Eq","Value":"","Show":"转入时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VTransfer.NewDeptName","Relation":"And","Operation":"Eq","Value":"","Show":"转入科室","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VClinicDiagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"门急诊协和诊断","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VClinicDiagnosis.InternalICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"门急诊协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.DiagnosisICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院北京诊断名称","DicTable":"Dic_ICD_Diagnosis","DicColumns":"ICD_Name,ICD_Code","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.DiagnosisICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"出院北京诊断编码","DicTable":"Dic_ICD_Diagnosis","DicColumns":"ICD_Code,ICD_Name","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalPathologyICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和病理编码","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.PathologyNum","Relation":"And","Operation":"Eq","Value":"","Show":"病理号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.DischargeState","Relation":"And","Operation":"Eq","Value":"","Show":"疗效","DicTable":"Dic_CurativeEffect","DicColumns":"CurativeEffectName,CurativeEffectCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Admitted","Relation":"And","Operation":"Eq","Value":"","Show":"入院病情","DicTable":"Dic_AdmissionCondition","DicColumns":"AdmissionConditionName,AdmissionConditionCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.InternalICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.OperateICDName","Relation":"And","Operation":"Eq","Value":"","Show":"北京手术名称","DicTable":"Dic_ICD_Operate","DicColumns":"ICD_Name,ICD_Code","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.OperateICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"北京手术编码","DicTable":"Dic_ICD_Operate","DicColumns":"ICD_Code,ICD_Name","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.OperateBeginTime","Relation":"And","Operation":"Eq","Value":"","Show":"手术开始时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.OperatorName","Relation":"And","Operation":"Eq","Value":"","Show":"手术术者","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.FirstAssistantSurgeon","Relation":"And","Operation":"Eq","Value":"","Show":"I助","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.SecondAssistantName","Relation":"And","Operation":"Eq","Value":"","Show":"II助","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.AnesthesiaType","Relation":"And","Operation":"Eq","Value":"","Show":"手术麻醉方式","DicTable":"Dic_Anesthesia","DicColumns":"Anesthesia,AnesthesiaCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.OperateLevel","Relation":"And","Operation":"Eq","Value":"","Show":"手术级别","DicTable":"Dic_OperationLevel","DicColumns":"OperationLevel","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.Cicatrize","Relation":"And","Operation":"Eq","Value":"","Show":"愈合等级","DicTable":"Dic_IncisionHealingLevel","DicColumns":"IncisionHealingLevel,IncisionHealingLevelCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.Anesthesiologist","Relation":"And","Operation":"Eq","Value":"","Show":"手术麻醉医生","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.AnesthesiaLevel","Relation":"And","Operation":"Eq","Value":"","Show":"手术麻醉分级","DicTable":"Dic_AnesthesiaLevel","DicColumns":"AnesthesiaLevel,AnesthesiaLevelCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和操作名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.InternalICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"协和操作编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.OperateICDName","Relation":"And","Operation":"Eq","Value":"","Show":"北京操作名称","DicTable":"Dic_ICD_Operate","DicColumns":"ICD_Name,ICD_Code","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.OperateICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"北京操作编码","DicTable":"Dic_ICD_Operate","DicColumns":"ICD_Code,ICD_Name","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.OperateBeginTime","Relation":"And","Operation":"Eq","Value":"","Show":"操作开始时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.OperatorName","Relation":"And","Operation":"Eq","Value":"","Show":"操作术者","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.FirstAssistantSurgeon","Relation":"And","Operation":"Eq","Value":"","Show":"操作I助","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.SecondAssistantName","Relation":"And","Operation":"Eq","Value":"","Show":"操作II助","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.AnesthesiaType","Relation":"And","Operation":"Eq","Value":"","Show":"操作麻醉方式","DicTable":"Dic_Anesthesia","DicColumns":"Anesthesia,AnesthesiaCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.OperateLevel","Relation":"And","Operation":"Eq","Value":"","Show":"操作级别","DicTable":"Dic_OperationLevel","DicColumns":"OperationLevel","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.Anesthesiologist","Relation":"And","Operation":"Eq","Value":"","Show":"操作麻醉医生","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.Cicatrize","Relation":"And","Operation":"Eq","Value":"","Show":"操作愈合等级","DicTable":"Dic_IncisionHealingLevel","DicColumns":"IncisionHealingLevel,IncisionHealingLevelCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.AnesthesiaLevel","Relation":"And","Operation":"Eq","Value":"","Show":"操作麻醉分级","DicTable":"Dic_AnesthesiaLevel","DicColumns":"AnesthesiaLevel,AnesthesiaLevelCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Doctor.主任医师.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"主任医师","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Doctor.主治医师.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"主治医师","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Doctor.主诊医师.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"主诊医师","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Doctor.责任护士.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"责任护士","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"CriticalMR","Relation":"And","Operation":"Eq","Value":"","Show":"危急重病例","DicTable":"","DicColumns":"value,show","Db":"","DataType":"","Options":[{"value":"是","show":"是"},{"value":"否","show":"否"}],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"IntractableMR","Relation":"And","Operation":"Eq","Value":"","Show":"疑难病例","DicTable":"Dic_IntractableMR","DicColumns":"IntractableMRName,IntractableMRCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VICU.EntryTime","Relation":"And","Operation":"Eq","Value":"","Show":"进重症监护室时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VICU.OutTime","Relation":"And","Operation":"Eq","Value":"","Show":"出重症监护室时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VICU.ICUName","Relation":"And","Operation":"Eq","Value":"","Show":"重症监护室名称","DicTable":"Dic_IcuType","DicColumns":"ICUName,ICUCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"M","Relation":"And","Operation":"Eq","Value":"","Show":"肿瘤分期(M)","DicTable":"Dic_Metastasis","DicColumns":"MetastasisName,MetastasisCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"N","Relation":"And","Operation":"Eq","Value":"","Show":"肿瘤分期(N)","DicTable":"Dic_LymphNode","DicColumns":"LymphNodeName,LymphNodeCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"T","Relation":"And","Operation":"Eq","Value":"","Show":"肿瘤分期(T)","DicTable":"Dic_TumorTNM","DicColumns":"TumorTNM,TumorTNMCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Tumorclinical","Relation":"And","Operation":"Eq","Value":"","Show":"肿瘤临床分期","DicTable":"Dic_Tumorclinical","DicColumns":"Tumorclinical,TumorclinicalCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"ADLAfter","Relation":"And","Operation":"Eq","Value":"","Show":"日常生活能力评定量表得分，出院","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"ADLBefore","Relation":"And","Operation":"Eq","Value":"","Show":"日常生活能力评定量表得分，入院","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"RespiratorTime","Relation":"And","Operation":"Eq","Value":"","Show":"呼吸机使用时间","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Totalcost","Relation":"And","Operation":"Eq","Value":"","Show":"总花费金额","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"SelfPayment","Relation":"And","Operation":"Eq","Value":"","Show":"自付金额","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.诊查费","Relation":"And","Operation":"Eq","Value":"","Show":"诊查费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.接生费","Relation":"And","Operation":"Eq","Value":"","Show":"接生费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.床位费","Relation":"And","Operation":"Eq","Value":"","Show":"床位费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.一般治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"一般治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.检查用一次性医用材料费","Relation":"And","Operation":"Eq","Value":"","Show":"检查用一次性医用材料费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.介入用一次性医用材料费","Relation":"And","Operation":"Eq","Value":"","Show":"介入用一次性医用材料费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.监护及辅助呼吸设备费","Relation":"And","Operation":"Eq","Value":"","Show":"监护及辅助呼吸设备费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.白蛋白类制品费","Relation":"And","Operation":"Eq","Value":"","Show":"白蛋白类制品费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.超声费","Relation":"And","Operation":"Eq","Value":"","Show":"超声费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.费用值","Relation":"And","Operation":"Eq","Value":"","Show":"费用值","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.核素检查","Relation":"And","Operation":"Eq","Value":"","Show":"核素检查","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.核素治疗","Relation":"And","Operation":"Eq","Value":"","Show":"核素治疗","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.挂号费","Relation":"And","Operation":"Eq","Value":"","Show":"挂号费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.护理费","Relation":"And","Operation":"Eq","Value":"","Show":"护理费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.输氧费","Relation":"And","Operation":"Eq","Value":"","Show":"输氧费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.护理治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"护理治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.病理费","Relation":"And","Operation":"Eq","Value":"","Show":"病理费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.化验费","Relation":"And","Operation":"Eq","Value":"","Show":"化验费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.放射费","Relation":"And","Operation":"Eq","Value":"","Show":"放射费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.一般检查费","Relation":"And","Operation":"Eq","Value":"","Show":"一般检查费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.介入治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"介入治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.精神治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"精神治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.康复治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"康复治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.抗菌药物费","Relation":"And","Operation":"Eq","Value":"","Show":"抗菌药物费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.临床物理治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"临床物理治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.麻醉费","Relation":"And","Operation":"Eq","Value":"","Show":"麻醉费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.凝血因子类制品费","Relation":"And","Operation":"Eq","Value":"","Show":"凝血因子类制品费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.其他","Relation":"And","Operation":"Eq","Value":"","Show":"其他","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.球蛋白类制品费","Relation":"And","Operation":"Eq","Value":"","Show":"球蛋白类制品费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.手术费","Relation":"And","Operation":"Eq","Value":"","Show":"手术费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.手术用一次性医用材料费","Relation":"And","Operation":"Eq","Value":"","Show":"手术用一次性医用材料费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.输血费","Relation":"And","Operation":"Eq","Value":"","Show":"输血费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.特殊治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"特殊治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.西药费","Relation":"And","Operation":"Eq","Value":"","Show":"西药费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.细胞因子类制品费","Relation":"And","Operation":"Eq","Value":"","Show":"细胞因子类制品费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.治疗用一次性医用材料费","Relation":"And","Operation":"Eq","Value":"","Show":"治疗用一次性医用材料费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.中草药费","Relation":"And","Operation":"Eq","Value":"","Show":"中草药费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.中成药费","Relation":"And","Operation":"Eq","Value":"","Show":"中成药费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VFee.中医治疗费","Relation":"And","Operation":"Eq","Value":"","Show":"中医治疗费","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"sequence":false,"strict":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}},"version":2}', CAST(N'2020-09-22T00:11:51.890' AS DateTime), N'', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020824121313635693', N'医生手术量分级统计', 1, 0, N'', N'{"name":"医生手术量分级统计","statistics":[{"conditions":[],"terms":[{"statistictype":"联合分组计数","target":"VSurgery.OperatorName","name":"手术术者","parameter":"","show":"手术术者"},{"statistictype":"联合分组计数","target":"VSurgery.OperateLevel","name":"手术级别","parameter":"","show":"手术级别"}],"caculateterms":[]}],"conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2019-01-01","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-03-01","Public":false,"IsShow":true}]}],"expression":"","parameter":{"isMridMode":false,"distinctMrid":false,"sequence":false,"strict":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}},"version":2}', CAST(N'2020-09-24T04:09:09.597' AS DateTime), N'admin', NULL, N'aggregation', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model20208918151781651', N'新的实验', 0, 0, N'', N'{"name":"新的实验","statistics":[{"conditions":[],"terms":[{"statistictype":"结果计数","target":"MRID","name":"病案号","parameter":"","show":"病案号"}],"caculateterms":[]}],"conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"I21.001,I21.002,I21.003,I21.004,I21.101,I21.102,I21.103,I21.104,I21.201,I21.202,I21.203,I21.204,I21.205,I21.206,I21.207,I21.208,I21.209,I21.210,I21.304,I21.305,I21.401,I21.402,I21.403,I21.901,I21.902","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]},{"name":"","relation":"Except","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"Z37.001,Z37.002,Z37.003,Z37.101,Z37.201,Z37.202,Z37.203,Z37.204,Z37.301,Z37.302,Z37.303,Z37.304,Z37.305,Z37.306,Z37.307,Z37.308,Z37.309,Z37.401,Z37.402,Z37.501,Z37.502,Z37.601","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"expression":"","parameter":{}}', CAST(N'2020-09-09T10:15:01.177' AS DateTime), N'admin', NULL, N'aggregation', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020811841267307', N'数据一致性查询', 0, 0, N'', N'{"name":"UntitledQuery","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2003-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-09-10T16:00:00.000Z","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"M10.061,M10.081,M10.091,M10.091,M10.092,M10.093,M10.094+I43.804*,M10.095,M10.191,M10.291,M10.391,M10.392,M10.991,M10.992+H62.801*","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDCode","Relation":"Or","Operation":"Eq","Value":"E79.001","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false},{"Target":"InDepart","Relation":"And","Operation":"Eq","Value":"","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.OperatorName","Relation":"And","Operation":"Eq","Value":"","Show":"手术术者","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"VSurgery.FirstAssistantSurgeon","Relation":"And","Operation":"Eq","Value":"","Show":"I助","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false},{"Target":"Doctor.主治医师.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"主治医师","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}}}', CAST(N'2020-09-11T00:33:38.853' AS DateTime), N'', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202081116275298196', N'测试 public', 0, 0, N'', N'{"name":"测试 public","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2003-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-08-31T16:00:00.000Z","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"M10.061,M10.081,M10.091,M10.091,M10.092,M10.093,M10.094+I43.804*,M10.095,M10.191,M10.291,M10.391,M10.392,M10.991,M10.992+H62.801*","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":true,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"Or","Operation":"Eq","Value":"E79.001","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":true,"IsShow":true},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InDepart","Relation":"And","Operation":"Eq","Value":"","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.OperatorName","Relation":"And","Operation":"Eq","Value":"","Show":"手术术者","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.FirstAssistantSurgeon","Relation":"And","Operation":"Eq","Value":"","Show":"I助","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Doctor.主治医师.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"主治医师","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}}}', CAST(N'2020-09-11T08:27:37.953' AS DateTime), N'', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020830154640821483', N'类固醇细胞瘤 妇科', 0, 0, N'', N'{"name":"类固醇细胞瘤 妇科","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VClinicDiagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"门急诊协和诊断","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.OperateBeginTime","Relation":"And","Operation":"Eq","Value":"","Show":"手术开始时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.OperatorName","Relation":"And","Operation":"Eq","Value":"","Show":"手术术者","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VContact.PhoneNum","Relation":"And","Operation":"Eq","Value":"","Show":"联系人电话","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"女","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"And","Operation":"Eq","Value":"非特异性类固醇细胞瘤","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"Or","Operation":"in","Value":"脂质细胞瘤,类脂质细胞瘤","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"Or","Operation":"Eq","Value":"黄体瘤","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"Or","Operation":"Eq","Value":"莱迪细胞瘤","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"sequence":false,"strict":false,"limit":{"Diagnosis":5,"VAllergyDiagnosis":0,"VClinicDiagnosis":2,"VOperate":null,"VSurgery":5,"VTransfer":0,"VContact":0,"VICU":0}},"version":3}', CAST(N'2020-09-30T06:51:11.453' AS DateTime), N'test', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020811154644327853', N'异次并发示例-诊断', 0, 0, N'', N'{"name":"异次并发示例-诊断","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2018-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2019-12-31T16:00:00.000Z","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"asyp","Value":"Z37.001,Z37.002,Z37.003,Z37.101,Z37.201,Z37.202,Z37.203,Z37.204,Z37.301,Z37.302,Z37.303,Z37.304,Z37.305,Z37.306,Z37.307,Z37.308,Z37.309,Z37.401,Z37.402,Z37.501,Z37.502,Z37.601","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"HospitalizedTimes","Relation":"And","Operation":"Eq","Value":"","Show":"住院次数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"asyp","Value":"C53.001,C53.901,C53.902,C53.903,C53.904,C53.905,C53.906,C53.907","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}},"version":2}', CAST(N'2020-09-11T07:44:46.973' AS DateTime), N'', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020814151511708932', N'第一例肠癌', 0, 0, N'', N'{"name":"第一例肠癌","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2000-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2002-12-31T16:00:00.000Z","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"asyp","Value":"C18.001,C18.002,C18.101,C18.102,C18.103,C18.201,C18.202,C18.301,C18.401,C18.501,C18.601,C18.701,C18.702,C18.703,C18.704,C18.801,C18.802,C18.803,C18.804,C18.805,C18.806,C18.901,C18.902,C18.903,C19  01,C19  02,C19  03,C20  01,C20  02,C20  03,C20  04,C20  05,C20  06","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"asyp","Value":"Z51.101,Z51.103,Z51.001,Z51.002,Z51.003,Z51.004,Z51.102,Z51.104,Z51.105,Z51.106,Z51.201,Z51.301,Z51.401,Z51.402,Z51.403,Z51.501,Z51.502,Z51.503,Z51.601,Z51.801,Z51.802,Z51.803,Z51.805,Z51.806,Z51.807,Z51.808,Z51.809,Z51.810,Z51.811,Z51.813,Z51.814,Z51.404","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InDepart","Relation":"And","Operation":"Eq","Value":"","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InSickRoom","Relation":"And","Operation":"Eq","Value":"","Show":"入院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}},"version":2}', CAST(N'2020-09-14T07:10:46.997' AS DateTime), N'', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020816142933681335', N'2001-2003 第一例肠癌', 0, 0, N'', N'{"name":"2001-2003 第一例肠癌","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2000-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2003-12-31T16:00:00.000Z","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"asyp","Value":"C18.001,C18.002,C18.101,C18.102,C18.103,C18.201,C18.202,C18.301,C18.401,C18.501,C18.601,C18.701,C18.702,C18.703,C18.704,C18.801,C18.802,C18.803,C18.804,C18.805,C18.806,C18.901,C18.902,C18.903,C19  01,C19  02,C19  03,C20  01,C20  02,C20  03,C20  04,C20  05,C20  06","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"asyp","Value":"Z51.101,Z51.103,Z51.001,Z51.002,Z51.003,Z51.004,Z51.102,Z51.104,Z51.105,Z51.106,Z51.201,Z51.301,Z51.401,Z51.402,Z51.403,Z51.501,Z51.502,Z51.503,Z51.601,Z51.801,Z51.802,Z51.803,Z51.805,Z51.806,Z51.807,Z51.808,Z51.809,Z51.810,Z51.811,Z51.813,Z51.814,Z51.404","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InDepart","Relation":"And","Operation":"Eq","Value":"","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InSickRoom","Relation":"And","Operation":"Eq","Value":"","Show":"入院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}},"version":2}', CAST(N'2020-09-16T05:24:40.233' AS DateTime), N'', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202099111333844750', N'赵珞', 0, 0, N'', N'{"name":"赵珞","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"InDepart","Relation":"And","Operation":"in","Value":"NFMK-内分泌科,HXNK-呼吸内科,MYNK-免疫内科,PTNK-普通内科,GRNK-感染内科","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"in","Value":"经皮肺活组织检查,开放性肺活组织检查,胸腔镜下肺活组织检查,胸腔镜下纵隔淋巴结活组织检查,腹腔镜下盆腔淋巴结活组织检查,纵隔镜下纵隔淋巴结活组织检查术,支气管镜下纵隔淋巴结活组织检查,前哨淋巴结活组织检查,腋窝淋巴结活组织检查,胸腔镜下胸膜活组织检查,胸膜活组织检查,闭合性胸膜活组织检查,单孔胸腔镜下胸膜活组织检查","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InDepart","Relation":"And","Operation":"Eq","Value":"","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.OperateBeginTime","Relation":"And","Operation":"Eq","Value":"","Show":"手术开始时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.OperatorName","Relation":"And","Operation":"Eq","Value":"","Show":"手术术者","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和操作名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.OperatorName","Relation":"And","Operation":"Eq","Value":"","Show":"操作术者","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]},{"name":"","relation":"Union","conditions":[{"Target":"VOperate.InternalICDName","Relation":"And","Operation":"in","Value":"经皮肺活组织检查,开放性肺活组织检查,胸腔镜下肺活组织检查,胸腔镜下纵隔淋巴结活组织检查,腹腔镜下盆腔淋巴结活组织检查,纵隔镜下纵隔淋巴结活组织检查术,支气管镜下纵隔淋巴结活组织检查,前哨淋巴结活组织检查,腹腔镜下淋巴结活检术,腋窝淋巴结活组织检查,单侧乳腺切除伴同侧腋窝淋巴结活检术,胸腔镜下胸膜活组织检查,胸膜活组织检查,闭合性胸膜活组织检查,单孔胸腔镜下胸膜活组织检查","Show":"协和操作名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false},{"Target":"InDepart","Relation":"And","Operation":"in","Value":"NFMK-内分泌科,HXNK-呼吸内科,MYNK-免疫内科,PTNK-普通内科,GRNK-感染内科","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"sequence":false,"strict":false,"limit":{"Diagnosis":5,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":7,"VSurgery":7,"VTransfer":0,"VContact":0,"VICU":0}},"version":3}', CAST(N'2020-10-09T02:11:56.630' AS DateTime), N'test', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202081714136152883', N'导出诊断限制', 0, 0, N'', N'{"name":"导出诊断限制","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2009-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-09-16T16:00:00.000Z","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"I50.001,I50.002,I50.003,I50.101,I50.102,I50.103,I50.104,I50.105,I50.901,I50.902,I50.903,I50.904,I50.905,I50.906,I50.907,I50.908,I50.909,I50.910,I50.911,I50.912,I50.913,I50.914,I50.915,I50.916,I50.917,I50.918,I50.919,I50.920,I50.921,I50.922,I50.923","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"HospitalizedTimes","Relation":"And","Operation":"Eq","Value":"","Show":"住院次数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VContact.PhoneNum","Relation":"And","Operation":"Eq","Value":"","Show":"联系人电话","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":true,"sequence":false,"strict":false,"limit":{"Diagnosis":7,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":5,"VSurgery":5,"VTransfer":0,"VContact":0,"VICU":0}},"version":2}', CAST(N'2020-09-17T06:01:11.067' AS DateTime), N'', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202081813523871560', N'2017至今胸外科出院', 0, 0, N'', N'{"name":"2017至今胸外科出院","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2016-12-31T16:00:00.000Z","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-09-17T16:00:00.000Z","Public":false,"IsShow":false},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"XWK-胸外科","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Birthday","Relation":"And","Operation":"Eq","Value":"","Show":"生日","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InDepart","Relation":"And","Operation":"Eq","Value":"","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InpatientDay","Relation":"And","Operation":"Eq","Value":"","Show":"住院天数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"HospitalizedTimes","Relation":"And","Operation":"Eq","Value":"","Show":"住院次数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PaymentType","Relation":"And","Operation":"Eq","Value":"","Show":"医疗付款方式","DicTable":"Dic_PayType","DicColumns":"PayTypeName,PayTypeCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Totalcost","Relation":"And","Operation":"Eq","Value":"","Show":"总花费金额","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"SelfPayment","Relation":"And","Operation":"Eq","Value":"","Show":"自付金额","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargePath","Relation":"And","Operation":"Eq","Value":"","Show":"离院方式","DicTable":"Dic_DischargeType","DicColumns":"DischargeType,DischargeCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Admitted","Relation":"And","Operation":"Eq","Value":"","Show":"入院病情","DicTable":"Dic_AdmissionCondition","DicColumns":"AdmissionConditionName,AdmissionConditionCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"BirthProvince","Relation":"And","Operation":"Eq","Value":"","Show":"出生地址（省）","DicTable":"BaseDic_Province","DicColumns":"ProvinceName,ProvinceCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"BirthCity","Relation":"And","Operation":"Eq","Value":"","Show":"出生地址（市）","DicTable":"BaseDic_City","DicColumns":"CityName,CityCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"BirthArea","Relation":"And","Operation":"Eq","Value":"","Show":"出生地址（县）","DicTable":"BaseDic_Area","DicColumns":"AreaName,AreaCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionPath","Relation":"And","Operation":"Eq","Value":"","Show":"入院途径","DicTable":"Dic_AdmissionPath","DicColumns":"AdmissionPath,AdmissionPathCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"ABO","Relation":"And","Operation":"Eq","Value":"","Show":"血型","DicTable":"Dic_BloodType","DicColumns":"BloodTypeName,BloodTypeCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"CriticalMR","Relation":"And","Operation":"Eq","Value":"","Show":"危急重病例","DicTable":"","DicColumns":"value,show","Db":"","DataType":"","Options":[{"value":"是","show":"是"},{"value":"否","show":"否"}],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"FollowUp","Relation":"And","Operation":"Eq","Value":"","Show":"是否随诊","DicTable":"Dic_FollowUp","DicColumns":"FollowUpName,FollowUpCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"IdType","Relation":"And","Operation":"Eq","Value":"","Show":"证件类型","DicTable":"Dic_IdType","DicColumns":"IdTypeName,IdTypeCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"IDCard","Relation":"And","Operation":"Eq","Value":"","Show":"证件号码","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InSickRoom","Relation":"And","Operation":"Eq","Value":"","Show":"入院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"IntractableMR","Relation":"And","Operation":"Eq","Value":"","Show":"疑难病例","DicTable":"Dic_IntractableMR","DicColumns":"IntractableMRName,IntractableMRCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Marriage","Relation":"And","Operation":"Eq","Value":"","Show":"婚姻状态","DicTable":"Dic_MarriageType","DicColumns":"MarriageTypeName,MarriageTypeCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"NativeProvince","Relation":"And","Operation":"Eq","Value":"","Show":"籍贯（省）","DicTable":"BaseDic_Province","DicColumns":"ProvinceName,ProvinceCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"ReadmissionIn31","Relation":"And","Operation":"Eq","Value":"","Show":"出院31天再入院计划","DicTable":"Dic_ReadmissionIn31","DicColumns":"ReadmissionIn31Name,ReadmissionIn31Code","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalPathologyICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和病理","DicTable":"Dic_ICD_Internal_Morphology","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.PathologyNum","Relation":"And","Operation":"Eq","Value":"","Show":"病理号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VClinicDiagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"门急诊协和诊断","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VClinicDiagnosis.ClinicDiagnosis","Relation":"And","Operation":"Eq","Value":"","Show":"门急诊临床诊断","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.OperateLevel","Relation":"And","Operation":"Eq","Value":"","Show":"手术级别","DicTable":"Dic_OperationLevel","DicColumns":"OperationLevel","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.OperatorName","Relation":"And","Operation":"Eq","Value":"","Show":"手术术者","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.Anesthesiologist","Relation":"And","Operation":"Eq","Value":"","Show":"手术麻醉医生","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.AnesthesiaType","Relation":"And","Operation":"Eq","Value":"","Show":"手术麻醉方式","DicTable":"Dic_Anesthesia","DicColumns":"Anesthesia,AnesthesiaCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.Cicatrize","Relation":"And","Operation":"Eq","Value":"","Show":"愈合等级","DicTable":"Dic_IncisionHealingLevel","DicColumns":"IncisionHealingLevel,IncisionHealingLevelCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.FirstAssistantSurgeon","Relation":"And","Operation":"Eq","Value":"","Show":"I助","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.SecondAssistantName","Relation":"And","Operation":"Eq","Value":"","Show":"II助","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.OperateBeginTime","Relation":"And","Operation":"Eq","Value":"","Show":"手术开始时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.ClinicalOperateName","Relation":"And","Operation":"Eq","Value":"","Show":"临床操作名称","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和操作名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.OperateLevel","Relation":"And","Operation":"Eq","Value":"","Show":"操作级别","DicTable":"Dic_OperationLevel","DicColumns":"OperationLevel","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VOperate.OperatorName","Relation":"And","Operation":"Eq","Value":"","Show":"操作术者","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Doctor.住院医师.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"住院医师","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Doctor.主任医师.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"主任医师","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Doctor.主治医师.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"主治医师","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Doctor.科主任.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"科主任","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VTransfer.NewDeptName","Relation":"And","Operation":"Eq","Value":"","Show":"转入科室","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VTransfer.TransferDate","Relation":"And","Operation":"Eq","Value":"","Show":"转入时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Adress","Relation":"And","Operation":"Eq","Value":"","Show":"联系人住址","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VContact.PhoneNum","Relation":"And","Operation":"Eq","Value":"","Show":"联系人电话","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"HukouProvince","Relation":"And","Operation":"Eq","Value":"","Show":"户口地址(省)","DicTable":"BaseDic_Province","DicColumns":"ProvinceName,ProvinceCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"HukouCity","Relation":"And","Operation":"Eq","Value":"","Show":"户口地址(市)","DicTable":"BaseDic_City","DicColumns":"CityName,CityCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"HukouArea","Relation":"And","Operation":"Eq","Value":"","Show":"户口地址(县)","DicTable":"BaseDic_Area","DicColumns":"AreaName,AreaCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"HukouAddressDetail","Relation":"And","Operation":"Eq","Value":"","Show":"户口住址详细地址","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"CurrentProvince","Relation":"And","Operation":"Eq","Value":"","Show":"现在地址（省）","DicTable":"BaseDic_Province","DicColumns":"ProvinceName,ProvinceCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"CurrentCity","Relation":"And","Operation":"Eq","Value":"","Show":"现在地址（市）","DicTable":"BaseDic_City","DicColumns":"CityName,CityCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"CurrentArea","Relation":"And","Operation":"Eq","Value":"","Show":"现在地址（县）","DicTable":"BaseDic_Area","DicColumns":"AreaName,AreaCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"CurrentAddressDetail","Relation":"And","Operation":"Eq","Value":"","Show":"现在住址详细地址","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VContact.ContactName","Relation":"And","Operation":"Eq","Value":"","Show":"联系人姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"sequence":false,"strict":false,"limit":{"Diagnosis":7,"VAllergyDiagnosis":0,"VClinicDiagnosis":2,"VOperate":7,"VSurgery":7,"VTransfer":2,"VContact":1,"VICU":1}},"version":2}', CAST(N'2020-09-18T05:36:44.830' AS DateTime), N'', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020823173325297507', N'新版测试', 0, 0, N'', N'{"name":"新版测试","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2020-09-01","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-09-24","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"in","Value":"I50.001,I50.002,I50.003,I50.101,I50.102,I50.103,I50.104,I50.105,I50.901,I50.902,I50.903,I50.904,I50.905,I50.906,I50.907,I50.908,I50.909,I50.910,I50.911,I50.912,I50.913,I50.914,I50.915,I50.916,I50.917,I50.918,I50.919,I50.920,I50.921,I50.922,I50.923","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"HospitalizedTimes","Relation":"And","Operation":"Eq","Value":"","Show":"住院次数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VContact.PhoneNum","Relation":"And","Operation":"Eq","Value":"","Show":"联系人电话","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":true,"sequence":false,"strict":false,"limit":{"Diagnosis":7,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":5,"VSurgery":5,"VTransfer":0,"VContact":0,"VICU":0}},"version":2}', CAST(N'2020-09-23T09:32:20.920' AS DateTime), N'admin', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020827135125408213', N'张萌要的查询', 1, 0, N'', N'{"name":"张萌要的查询","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2020-01-01","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-09-01","Public":false,"IsShow":true},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InDepart","Relation":"And","Operation":"Eq","Value":"","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InpatientDay","Relation":"And","Operation":"Eq","Value":"","Show":"住院天数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargePath","Relation":"And","Operation":"Eq","Value":"","Show":"离院方式","DicTable":"Dic_DischargeType","DicColumns":"DischargeType,DischargeCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"RespiratorTime","Relation":"And","Operation":"Eq","Value":"","Show":"呼吸机使用时间","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VICU.ICUName","Relation":"And","Operation":"Eq","Value":"","Show":"重症监护室名称","DicTable":"Dic_IcuType","DicColumns":"ICUName,ICUCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断编码","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.InternalICDCode","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VSurgery.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"协和手术名称","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InSickRoom","Relation":"And","Operation":"Eq","Value":"","Show":"入院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutSickRoom","Relation":"And","Operation":"Eq","Value":"","Show":"出院病房","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}}}', CAST(N'2020-09-27T05:49:44.717' AS DateTime), N'test', NULL, N'query', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020824152256923840', N'医生工作量统计示例', 1, 0, N'', N'{"name":"医生工作量统计示例","statistics":[{"conditions":[],"terms":[{"statistictype":"联合分组计数","target":"VSurgery.OperatorName","name":"手术术者","parameter":"","show":"手术术者"},{"statistictype":"联合分组计数","target":"VSurgery.OperateICDCode","name":"北京手术编码","parameter":"","show":"北京手术编码"}],"caculateterms":[]}],"conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":">","Value":"2020-07-01","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"expression":"","parameter":{"isMridMode":false,"distinctMrid":false,"sequence":false,"strict":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}},"version":2}', CAST(N'2020-09-24T07:19:15.880' AS DateTime), N'admin', NULL, N'aggregation', N'')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model2020827134917425767', N'示例：编码可以使用between了', 1, 0, N'', N'{"name":"示例：编码可以使用between了","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"DischargeDateTime","Relation":"And","Operation":"between","Value":"2020-09-01","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"2020-09-15","Public":false,"IsShow":true},{"Target":"VSurgery.InternalICDCode","Relation":"And","Operation":"between","Value":"30","Show":"协和手术编码","DicTable":"Dic_ICD_Internal_Operate","DicColumns":"InternalICDCode,InternalICDName","Db":"","DataType":"","Options":[],"AddtionalValue":"34","Public":false,"IsShow":true},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InpatientDay","Relation":"And","Operation":"Eq","Value":"","Show":"住院天数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"HospitalizedTimes","Relation":"And","Operation":"Eq","Value":"","Show":"住院次数","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InDepart","Relation":"And","Operation":"Eq","Value":"","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Doctor.编码员.姓名","Relation":"And","Operation":"Eq","Value":"","Show":"编码员","DicTable":"Base_User","DicColumns":"Name,EmployeeId,Note","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"MRQuantity","Relation":"And","Operation":"Eq","Value":"","Show":"病案质量","DicTable":"Dic_MRQuality","DicColumns":"Quality,QualityCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}},"version":2}', CAST(N'2020-09-27T05:47:18.940' AS DateTime), N'test', NULL, N'query', N'协和手术编码使用了between进行查询')
GO
INSERT [dbo].[Table_Model]
    ([id], [name], [shared], [grade], [sharedUser], [query], [createTime], [owner], [lastExecuteTime], [type], [description])
VALUES
    (N'model202099162141410', N'检索1', 0, 0, N'', N'{"name":"检索1","conditionpipe":[{"name":"","relation":"Intercect","conditions":[{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"外阴子宫内膜异位症,会阴子宫内膜异位症,直肠阴道隔子宫内膜异位症,阴道子宫内膜异位症","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":false},{"Target":"PatientName","Relation":"And","Operation":"Eq","Value":"","Show":"患者姓名","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Gender","Relation":"And","Operation":"Eq","Value":"","Show":"性别","DicTable":"Dic_Gender","DicColumns":"GenderName,GenderCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Age","Relation":"And","Operation":"Eq","Value":"","Show":"年龄","DicTable":"","DicColumns":"","Db":"","DataType":"num","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"MRID","Relation":"And","Operation":"Eq","Value":"","Show":"病案号","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"AdmissionDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"入院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"InDepart","Relation":"And","Operation":"Eq","Value":"","Show":"入院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"DischargeDateTime","Relation":"And","Operation":"Eq","Value":"","Show":"出院时间","DicTable":"","DicColumns":"","Db":"","DataType":"date","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"OutDepart","Relation":"And","Operation":"Eq","Value":"","Show":"出院科别","DicTable":"Base_Department","DicColumns":"Name,DepCode","Db":"SecurityDB","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"Diagnosis.InternalICDName","Relation":"And","Operation":"Eq","Value":"","Show":"出院协和诊断名称","DicTable":"Dic_ICD_Internal_Diagnosis","DicColumns":"InternalICDName,InternalICDCode","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true},{"Target":"VContact.PhoneNum","Relation":"And","Operation":"Eq","Value":"","Show":"联系人电话","DicTable":"","DicColumns":"","Db":"","DataType":"","Options":[],"AddtionalValue":"","Public":false,"IsShow":true}]}],"showColumn":[],"parameter":{"isMridMode":false,"distinctMrid":false,"sequence":false,"strict":false,"limit":{"Diagnosis":0,"VAllergyDiagnosis":0,"VClinicDiagnosis":0,"VOperate":0,"VSurgery":0,"VTransfer":0,"VContact":0,"VICU":0}},"version":3}', CAST(N'2020-10-09T08:15:51.023' AS DateTime), N'test', NULL, N'query', N'')
GO
